Archive Magazine CD 1995/Archive Magazine CD 1995.iso/discs/pipeline/5_10/MacroCount/ReadMe

Text File | 1992-06-04 | 6.5 KB | 695 lines

%OP%VS4.13 (28-Apr-92), Gerald L Fitton, R4000 5966 9904 9938
%OP%DP0
%OP%IRY
%OP%PL0
%OP%HM0
%OP%FM0
%OP%BM0
%OP%LM4
%OP%PT1
%OP%PDPipeLine
%OP%WC1010,2262,44,1748,0,0,0,0
%OP%NDfr,E52E56
%OP%NDge,F52F55
%OP%NDhi,G52G55
%OP%NDgo,H52H55
%OP%NDcd,L7L251
%OP%NDmt,M7M251
%OP%NDte,N7N251
%OP%NDmv,O7O251
%OP%NDbu,P7P251
%OP%NDar,R7R251
%OP%NDgr,S7S251
%OP%NDph,T7T251
%OP%NDpe,U7U251
%OP%NDit,W7W251
%OP%NDhf,X7X251
%OP%NDht,Y7Y251
%OP%NDbs,Z7Z251
%OP%NDcc,AA7AA251
%OP%NDSex,D52D55
%CO:A,3,72%
%C%Options
%C%by Peter Blenkinsop
Keywords:
Curriculum Options Students Records Blenkinsop

[This is the text of a letter I received from Peter Blenkinsop - GLF]

Dear Gerald

I thought I would send you a PipeDream 4 application which I use for
option groups in a secondary school.  Students in year 9 (third year
pre national curriculum) choose the subjects they are going to follow
on to GCSE in year 11.  Most school have a compulsory bit and an
optional bit.  One can opt for French or German etc.

I have included a small section of my option list application to
explain how it works.

But first- what does it do?

1




2




3


4



5


6









N
A
M
E
S













The spreadsheet is set up with two columns for the name, one for the
gender, one for each subject plus some blank columns to make the sheet
more readable.  The rows are totalled (not shown above) to allow the
number of choices made to be checked.


Entering student data

If a student chooses a subject the number 1 is entered against the
student name in the subject column.  In the above example Evelyn Anim
chose French.  This is repeated for all students.

PipeDream 4 allows the naming of  areas of the spreadsheet as an
alternative to giving a range.  This makes the setting up more logical.
I call the column under the label Fr by a name.  After a great deal of
thought I choose Fr!!  I could have used French as the name for the
column but that involves more typing.  Thereafter I can refer to that
column as Fr rather than E37E40 as in the example above.  All the
columns are named suitably.  I had set this sheet up in PipeDream 3 and
it worked there but I had to refer to the columns explicitly.  The
column total is then sum(Fr), for example.

When completed the sheet is printed out and form tutors check that the
entries are correct.   They never are!!!

Different Groups

There are more than one French group/set in year 10.  The groups are
called set 1, set 2 etc.  To place a student into set 2 French simply
change the 1 to a 2.

After the initial setting up of the timetable I am not too interested
in the numbers in total.  I am interested in the group sizes however.


Lists

PipeDream 4 has command files which had their equivalent in PipeDream 3
called Macros.  These can be entered using the keyboard copy facility
<Ctrl FY>  doing the various bits and then saving the file using
<Ctrl FY> again.  <Ctrl FZ> recalls and runs the file.

My list generating macro/command file is of the form

- mark the block of columns containing the names
- look down the column marked Fr and note the names where the cell
  contains a number
- store this name with all the others that take french in group 1
- put them all together with the other subjects.


It looks like

\Cgs|i "A2" |m        Go to slot
\Z|m      Mark block
\Cbc|m    Bottom of column
\Cnc|m    Next column
\Z|m      Mark block
\Fs|i "SCSI::SCSIDisc4.$.Fi*.Do*.Sc*.MS*.92/93.t*.fr1" |i Y |i "Fr=1"
                                       |i Y |i "LF" |i T |m        Save

etc for other subject columns.

\Fs|i "SCSI::SCSIDisc4.$.Fi*.Do*.Sc*.MS*.92/93.t*.fr2" |i Y |i "Fr=2"
                                      |i Y |i "LF" |i T |m        Save

The slightly altered line "Fr=2" would save those students who were in
French group 2.  It would save the file as fr2.

This saves the subject lists as separate files.

I then have a second part to the command file which loads all these
files into one PipeDream document with headings for the various
subjects for distribution within the school.

What does this line mean?

\Fs|i "SCSI::SCSIDisc4.$.Fi*.Do*.Sc*.MS*.92/93.t*.fr1" |i Y |i "Fr=1"
                                     |i Y |i "LF" |i T |m        Save

<Ctrl FS>       File name          fr1       Column = 1       save it

If you create a command file or macro then you can look at it just by
dragging it to PipeDream.  If you click it then it runs.  Make one as
that is the best way to understand how they work.  They look awful but
they are really quite simple!!


Peter Blenkinsop
5 Leggatts Close
Watford
Herts
WD2 6BG

25th April 1992
%CO:B,8,69%




















It keeps a record of choices in a form that can be easily modified.
Students often make provisional choices and then have to make some
adjustments if a timetable cannot be constructed to allow all the
various choices to occur.

It checks that the number of choices is correct.  No one has chosen
two subjects in the same option block.  In my school one cannot
choose French and German.  The total number of subjects chosen can
be displayed for this check.

It totals the number choosing each subject.  It totals the number of
males and the number of females.

It calculates the percentage of the year by gender, ie the
percentage of boys taking Home Economics or the girls taking
Information Technology.

It can easily be altered if a student changes from one subject to
another of staff move a student from one subject group to another.

Lists can be generated.  This is the most useful part.  My school
has a currently rapidly rising roll and the groups change almost
daily, and certainly monthly.  This system can easily be altered and
new lists printed.



Form
9CB

Evelyn
Nii
Rizia
Lutfun




Column
%CO:C,8,61%


















































Anim
Ayisi
Beg
Begum




Totals    ::::
Totals

Male
Female

%PC% Male
%PC% Female
%CO:D,7,53%















































Gender


F
M
F
F
%CO:E,5,46%















































Fr


%V%%L%%D0%1
%V%%L%2




Fr

%V%%L%62


%V%%L%35
%V%%L%27

%V%%L%61
%V%%L%64
%CO:F,5,41%















































Ge




%V%%L%1
%V%%L%1


Ge

%V%%L%37
%V%%L%99

%V%%L%22
%V%%L%15

%V%%L%39
%V%%L%36
%CO:G,5,36%















































Hi








Hi

%V%%L%25


%V%%L%11
%V%%L%14

%V%%L%19
%V%%L%33
%CO:H,5,31%















































Go


%V%%L%1
%V%%L%1
%V%%L%3
%V%%L%1


Go

%V%%L%74
%V%%L%99

%V%%L%46
%V%%L%28

%V%%L%81
%V%%L%67
%CO:I,3,26%%CO:J,3,23%















































More subjects
------------>
%CO:K,20,20%